﻿This ARMER2017readme.txt file was generated on 20190514 by Lisa Jordan and James Kalin


-------------------
GENERAL INFORMATION
-------------------


Title of Dataset: Annual Firearms Manufacturing and Export Report, 2017


Original Data Available in .PDF format from the Bureau of Alcohol, Firearms and Tobacco (ATF), 
published January 30, 2019.  
saved as afmer_2017_final.pdf.


Data Conversion Information:


        Completed by: Lisa Jordan, Drew University, 36 Madison Ave., Madison, NJ,                                           
			ljordan@drew.edu
                      James Kalin, Drew University, 36 Madison Ave., Madison, NJ
                      Jason Jordan, Drew University, 36 Madison Ave., Madison, NJ


Date of data conversion: 20190514


Geographic location of data conversion: Drew University, Madison, New Jersey 07940, USA


Funding for this project came from the Drew University Digital Humanities Summer Institute (DHSI), funded by a grant from the Andrew W. Mellon Foundation.


--------------------------
SHARING/ACCESS INFORMATION
-------------------------- 

Licenses/restrictions placed on the data, or limitations of reuse: as is

Recommended citation for the data: 

ATF. 2019. "Annual Firearms Manufacturing and Export Report, 2017." Originally published by the Bureau of Alcohol, Firearms and Tobacco (ATF), 30 January 2019, Washington, DC. Downloaded 14 May 2019 from https://www.atf.gov/file/133476/download as afmer_2017_final.pdf.  Data Compiled and Aggregated to .csv format by L. Jordan, J. Kalin, J. Jordan. 14 May. Available online from Harvard Dataverse.


--------------------
DATA & FILE OVERVIEW
--------------------


ARMER2017.zip  includes the following files:
File list (filenames, directory structure (for zipped files) and brief description of all data files):


ARMER2017.csv: included all data from ATF, 2019, and two new columns (fields): Export_Total, and Manufacturing_Total.  Please note: data are listed by RDS KEY, a unique identifier by manufacturer location.  There are multiple instances for some companies (e.g. Sturm, Ruger & Company, Inc. is listed as producing in multiple locations, and contains different records or rows for each location).  




Export_Misc.csv: Miscellaneous Firearm Exports by location
Export_Pistols.csv: Export Pistols by location
Export_Revolvers.csv: Export Revolvers by location
Export_Rifles.csv: Export Rifles by location
Export_Shotgun.csv: Export Shotguns by location


Misc: Miscellaneous Firearms Manufactured
Pistols: Pistols Manufactured, by Type
Revolvers: Revolvers Manufactured, by Type
Rifles; Rifles Manufactured, by Type
Shotguns: Shotguns Manufactured, by Type


We observed that some values were listed as zero by the ATF, and some cells were listed as blank.  


Relationship between files:  ARMER2017 includes all data from the other files. 


If data was derived from another source, list source: 
ATF, 2019. ANNUAL FIREARMS MANUFACTURING AND EXPORT REPORT 2017


--------------------------
METHODOLOGICAL INFORMATION
--------------------------


Description of methods used for collection/generation of data: 


AMER2017.csv was created by 1) converting the ATF .PDF report was extracted into several different files based on gun type, then converted into a .csv file using tabula (https://tabula.technology/), 2) the data were cleaned and verified by data compilers and saved as separate .csv files (these elements are listed and included as separate files below), 3) merged using stata based on the RDS KEY: a unique identifier used by the ATF in processing Federally Licensed Firearms Manufacturers, and 4)  new columns called Export_Total and Manufacting_Total were created.  Export_Total sums all export firearms listed by ATF.  Manufacturing_Total sums all manufacturing totals listed by ATF.  We observed that some locations did not have manufacturing numbers listed, but did list export numbers listed.  In a few cases, some locations had neither manufacturing nor export values listed.


Software: .csv files may be viewed in Microsoft Excel, Google Sheets, or in a text reader, such as notepad, or through a web browser. 


--------------------------
DATA-SPECIFIC INFORMATION
--------------------------


ARMER2017.csv


Number of variables: 29
Number of cases/rows: 2162 records


Variable list: most variable names were adopted from the original ATF document  


rds_key: ID number, unique to each license by location, not by company (company names may duplicate)
license_name: name of federal firearms manufacturer licensee
street: location of manufacturer
city: city name
state: state US postal code


rifle_mfg: number of rifles manufactured, 2017


exp_misc: number of miscellaneous firearms exported, 2017
exp_pistols: number of pistols exported, 2017
exp_revolvers: number of revolvers exported, 2017
rifle_exp: number of rifles exported, 2017
shotgun_exp: number of shotguns exported, 2017


misc_fa_mfg: number of miscellaneous firearms manufactured, 2017


pistol22: number of 22 caliber pistols manufactured, 2017
pistol25: number of 25 caliber pistols manufactured, 2017
pistol32: number of 32 caliber pistols manufactured, 2017
pistol380: number of pistol 380s manufactured, 2017
pistol9mm: number of 9mm pistols manufactured, 2017
pistol50: number of 50 caliber pistols manufactured, 2017
pistol_total: total number of pistols, all types, manufactured, 2017


rvlr22: number of 22 caliber revolvers manufactured, 2017
rvlr32: number of 32 caliber revolvers manufactured, 2017
rvlr357: number of 357 revolvers manufactured, 2017
rvlr38: number of 38 caliber revolvers manufactured, 2017
rvlr44: number of 44 caliber revolvers manufactured, 2017
rvlr50: number of 50 caliber revolvers manufactured, 2017
rvlrtotl: total number of revolvers manufactured, 2017


shotgun_mfg: number of shotguns manufactured, 2017


Export_Total: the sum of exp_misc, exp_pistols, exp_revolvers, rifle_exp, and shotgun_exp
Manufactured_Total: the sum of rifle_mfg, misc_fa_mfg, pistol_total, rvlrtotl, shotgun_mfg


Missing data codes: left blank, <NULL>




This metadata is based on the Cornell University readme template, available online: https://cornell.box.com/v/ReadmeTemplate [last downloaded 14 May 2019]